using HKB.Common;
using System;
using System.CodeDom.Compiler;
using System.ComponentModel;
using System.ComponentModel.Design;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Diagnostics;
namespace HKB.Data.Dal.S_ProductTableAdapters
{
	[GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0"), DataObject(true), HelpKeyword("vs.data.TableAdapter"), Designer("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"), DesignerCategory("code"), ToolboxItem(true)]
	public class HLShop_ProductTableAdapter : Component
	{
		private SqlDataAdapter _adapter;
		private SqlConnection _connection;
		private SqlCommand[] _commandCollection;
		private bool _clearBeforeFill;
		[System.Diagnostics.DebuggerNonUserCode]
		private SqlDataAdapter Adapter
		{
			get
			{
				if (this._adapter == null)
				{
					this.InitAdapter();
				}
				return this._adapter;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		internal SqlConnection Connection
		{
			get
			{
				if (this._connection == null)
				{
					this.InitConnection();
				}
				return this._connection;
			}
			set
			{
				this._connection = value;
				if (this.Adapter.InsertCommand != null)
				{
					this.Adapter.InsertCommand.Connection = value;
				}
				if (this.Adapter.DeleteCommand != null)
				{
					this.Adapter.DeleteCommand.Connection = value;
				}
				if (this.Adapter.UpdateCommand != null)
				{
					this.Adapter.UpdateCommand.Connection = value;
				}
				for (int i = 0; i < this.CommandCollection.Length; i++)
				{
					if (this.CommandCollection[i] != null)
					{
						this.CommandCollection[i].Connection = value;
					}
				}
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		protected SqlCommand[] CommandCollection
		{
			get
			{
				if (this._commandCollection == null)
				{
					this.InitCommandCollection();
				}
				return this._commandCollection;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		public bool ClearBeforeFill
		{
			get
			{
				return this._clearBeforeFill;
			}
			set
			{
				this._clearBeforeFill = value;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		public HLShop_ProductTableAdapter()
		{
			this.ClearBeforeFill = true;
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitAdapter()
		{
			this._adapter = new SqlDataAdapter();
			DataTableMapping dataTableMapping = new DataTableMapping();
			dataTableMapping.SourceTable = "Table";
			dataTableMapping.DataSetTable = "HLShop_Product";
			dataTableMapping.ColumnMappings.Add("ProductID", "ProductID");
			dataTableMapping.ColumnMappings.Add("ChannelID", "ChannelID");
			dataTableMapping.ColumnMappings.Add("ProductPlace", "ProductPlace");
			dataTableMapping.ColumnMappings.Add("ShopID", "ShopID");
			dataTableMapping.ColumnMappings.Add("ProductNum", "ProductNum");
			dataTableMapping.ColumnMappings.Add("ClassID", "ClassID");
			dataTableMapping.ColumnMappings.Add("ProductName", "ProductName");
			dataTableMapping.ColumnMappings.Add("ProductModel", "ProductModel");
			dataTableMapping.ColumnMappings.Add("ProductStandard", "ProductStandard");
			dataTableMapping.ColumnMappings.Add("ProducerName", "ProducerName");
			dataTableMapping.ColumnMappings.Add("TrademarkName", "TrademarkName");
			dataTableMapping.ColumnMappings.Add("ProductExplain", "ProductExplain");
			dataTableMapping.ColumnMappings.Add("ProductIntro", "ProductIntro");
			dataTableMapping.ColumnMappings.Add("StandPrice", "StandPrice");
			dataTableMapping.ColumnMappings.Add("ImcrementPrice", "ImcrementPrice");
			dataTableMapping.ColumnMappings.Add("AuctionStartPrice", "AuctionStartPrice");
			dataTableMapping.ColumnMappings.Add("CurrentPrice", "CurrentPrice");
			dataTableMapping.ColumnMappings.Add("TeamPrice1", "TeamPrice1");
			dataTableMapping.ColumnMappings.Add("TeamNumber1", "TeamNumber1");
			dataTableMapping.ColumnMappings.Add("TeamPrice2", "TeamPrice2");
			dataTableMapping.ColumnMappings.Add("TeamNumber2", "TeamNumber2");
			dataTableMapping.ColumnMappings.Add("OnTop", "OnTop");
			dataTableMapping.ColumnMappings.Add("IsHot", "IsHot");
			dataTableMapping.ColumnMappings.Add("IsElite", "IsElite");
			dataTableMapping.ColumnMappings.Add("Stars", "Stars");
			dataTableMapping.ColumnMappings.Add("Stocks", "Stocks");
			dataTableMapping.ColumnMappings.Add("OrderNum", "OrderNum");
			dataTableMapping.ColumnMappings.Add("AlarmNum", "AlarmNum");
			dataTableMapping.ColumnMappings.Add("EnableSale", "EnableSale");
			dataTableMapping.ColumnMappings.Add("Discount", "Discount");
			dataTableMapping.ColumnMappings.Add("BeginDate", "BeginDate");
			dataTableMapping.ColumnMappings.Add("EndDate", "EndDate");
			dataTableMapping.ColumnMappings.Add("LimitNum", "LimitNum");
			dataTableMapping.ColumnMappings.Add("Keyword", "Keyword");
			dataTableMapping.ColumnMappings.Add("CommentCount", "CommentCount");
			dataTableMapping.ColumnMappings.Add("UpdateTime", "UpdateTime");
			dataTableMapping.ColumnMappings.Add("CreateTime", "CreateTime");
			dataTableMapping.ColumnMappings.Add("Hits", "Hits");
			dataTableMapping.ColumnMappings.Add("BuyTimes", "BuyTimes");
			dataTableMapping.ColumnMappings.Add("Inputer", "Inputer");
			dataTableMapping.ColumnMappings.Add("SalePromotionType", "SalePromotionType");
			dataTableMapping.ColumnMappings.Add("PresentNumber", "PresentNumber");
			dataTableMapping.ColumnMappings.Add("PresentID", "PresentID");
			dataTableMapping.ColumnMappings.Add("PresentPoint", "PresentPoint");
			dataTableMapping.ColumnMappings.Add("PresentMoney", "PresentMoney");
			dataTableMapping.ColumnMappings.Add("PresentExp", "PresentExp");
			dataTableMapping.ColumnMappings.Add("Weight", "Weight");
			dataTableMapping.ColumnMappings.Add("EnableSingleSell", "EnableSingleSell");
			dataTableMapping.ColumnMappings.Add("DependentProducts", "DependentProducts");
			dataTableMapping.ColumnMappings.Add("TeamPrice3", "TeamPrice3");
			dataTableMapping.ColumnMappings.Add("TeamCurrentNumber1", "TeamCurrentNumber1");
			dataTableMapping.ColumnMappings.Add("TeamNumber3", "TeamNumber3");
			dataTableMapping.ColumnMappings.Add("TeamCurrentNumber2", "TeamCurrentNumber2");
			dataTableMapping.ColumnMappings.Add("TeamCurrentNumber3", "TeamCurrentNumber3");
			dataTableMapping.ColumnMappings.Add("SalerID", "SalerID");
			dataTableMapping.ColumnMappings.Add("EmailSent", "EmailSent");
			dataTableMapping.ColumnMappings.Add("MemberPrice", "MemberPrice");
			dataTableMapping.ColumnMappings.Add("PUnit", "PUnit");
			dataTableMapping.ColumnMappings.Add("ValidDay", "ValidDay");
			dataTableMapping.ColumnMappings.Add("PayType", "PayType");
			dataTableMapping.ColumnMappings.Add("Propority", "Propority");
			dataTableMapping.ColumnMappings.Add("DeliverType", "DeliverType");
			dataTableMapping.ColumnMappings.Add("DeliverCharge", "DeliverCharge");
			dataTableMapping.ColumnMappings.Add("NeedInvoice", "NeedInvoice");
			dataTableMapping.ColumnMappings.Add("Guarantee", "Guarantee");
			dataTableMapping.ColumnMappings.Add("DeliverPayType", "DeliverPayType");
			dataTableMapping.ColumnMappings.Add("OrderBy", "OrderBy");
			dataTableMapping.ColumnMappings.Add("ShopProductClassID", "ShopProductClassID");
			dataTableMapping.ColumnMappings.Add("ShopProductCategoryID", "ShopProductCategoryID");
			dataTableMapping.ColumnMappings.Add("ProductImageUrl", "ProductImageUrl");
			dataTableMapping.ColumnMappings.Add("CurrentBidderID", "CurrentBidderID");
			dataTableMapping.ColumnMappings.Add("BidTimes", "BidTimes");
			dataTableMapping.ColumnMappings.Add("Remark", "Remark");
			dataTableMapping.ColumnMappings.Add("ProductClassName", "ProductClassName");
			dataTableMapping.ColumnMappings.Add("Province", "Province");
			dataTableMapping.ColumnMappings.Add("City", "City");
			dataTableMapping.ColumnMappings.Add("ProductKind", "ProductKind");
			dataTableMapping.ColumnMappings.Add("TemplateID", "TemplateID");
			dataTableMapping.ColumnMappings.Add("SkinID", "SkinID");
			dataTableMapping.ColumnMappings.Add("PresentExp3", "PresentExp3");
			dataTableMapping.ColumnMappings.Add("PresentPoint3", "PresentPoint3");
			dataTableMapping.ColumnMappings.Add("PresentMoney3", "PresentMoney3");
			dataTableMapping.ColumnMappings.Add("Discount3", "Discount3");
			dataTableMapping.ColumnMappings.Add("PresentExp2", "PresentExp2");
			dataTableMapping.ColumnMappings.Add("PresentPoint2", "PresentPoint2");
			dataTableMapping.ColumnMappings.Add("PresentMoney2", "PresentMoney2");
			dataTableMapping.ColumnMappings.Add("Discount2", "Discount2");
			dataTableMapping.ColumnMappings.Add("PresentExp1", "PresentExp1");
			dataTableMapping.ColumnMappings.Add("PresentPoint1", "PresentPoint1");
			dataTableMapping.ColumnMappings.Add("PresentMoney1", "PresentMoney1");
			dataTableMapping.ColumnMappings.Add("Discount1", "Discount1");
			dataTableMapping.ColumnMappings.Add("LeftTime", "LeftTime");
			dataTableMapping.ColumnMappings.Add("TeamPrice5", "TeamPrice5");
			dataTableMapping.ColumnMappings.Add("TeamNumber5", "TeamNumber5");
			dataTableMapping.ColumnMappings.Add("TeamPrice4", "TeamPrice4");
			dataTableMapping.ColumnMappings.Add("TeamNumber4", "TeamNumber4");
			dataTableMapping.ColumnMappings.Add("TeamCurrentNumber4", "TeamCurrentNumber4");
			dataTableMapping.ColumnMappings.Add("TeamCurrentNumber5", "TeamCurrentNumber5");
			dataTableMapping.ColumnMappings.Add("TeamNum", "TeamNum");
			dataTableMapping.ColumnMappings.Add("TempSubScriptionRate", "TempSubScriptionRate");
			dataTableMapping.ColumnMappings.Add("TeamName", "TeamName");
			dataTableMapping.ColumnMappings.Add("ProductSmallImageUrl", "ProductSmallImageUrl");
			dataTableMapping.ColumnMappings.Add("TaxRate", "TaxRate");
			dataTableMapping.ColumnMappings.Add("AutoPostBack", "AutoPostBack");
			dataTableMapping.ColumnMappings.Add("CanTeam", "CanTeam");
			dataTableMapping.ColumnMappings.Add("CanSee", "CanSee");
			dataTableMapping.ColumnMappings.Add("CanBuy", "CanBuy");
			dataTableMapping.ColumnMappings.Add("UploadFiles", "UploadFiles");
			dataTableMapping.ColumnMappings.Add("ProductType", "ProductType");
			dataTableMapping.ColumnMappings.Add("Color", "Color");
			dataTableMapping.ColumnMappings.Add("Size", "Size");
			dataTableMapping.ColumnMappings.Add("CustomPrice", "CustomPrice");
			this._adapter.TableMappings.Add(dataTableMapping);
			this._adapter.DeleteCommand = new SqlCommand();
			this._adapter.DeleteCommand.Connection = this.Connection;
			this._adapter.DeleteCommand.CommandText = "DELETE FROM [HLShop_Product] WHERE (([ProductID] = @Original_ProductID))";
			this._adapter.DeleteCommand.CommandType = CommandType.Text;
			this._adapter.DeleteCommand.Parameters.Add(new SqlParameter("@Original_ProductID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Original, false, null, "", "", ""));
			this._adapter.InsertCommand = new SqlCommand();
			this._adapter.InsertCommand.Connection = this.Connection;
			this._adapter.InsertCommand.CommandText = "INSERT INTO [HLShop_Product] ([ShopID], [SalerID], [ChannelID], [ProductPlace], [ProductNum], [ClassID], [ProductName], [ProductModel], [ProductStandard], [ProducerName], [TrademarkName], [ProductIntro], [ProductExplain], [ProductImageUrl], [ProductSmallImageUrl], [UploadFiles], [StandPrice], [AuctionStartPrice], [ImcrementPrice], [CurrentPrice], [CurrentBidderID], [EmailSent], [BidTimes], [MemberPrice], [TeamName], [TeamNum], [TeamPrice1], [TempSubScriptionRate], [TeamNumber1], [TeamPrice2], [TeamNumber2], [TeamPrice3], [TeamNumber3], [TeamPrice4], [TeamNumber4], [TeamPrice5], [TeamNumber5], [TeamCurrentNumber1], [TeamCurrentNumber2], [TeamCurrentNumber3], [TeamCurrentNumber4], [TeamCurrentNumber5], [PUnit], [OnTop], [IsHot], [IsElite], [Stars], [Stocks], [OrderNum], [AlarmNum], [EnableSale], [BeginDate], [EndDate], [LimitNum], [Keyword], [CommentCount], [UpdateTime], [CreateTime], [Hits], [BuyTimes], [Inputer], [ValidDay], [SalePromotionType], [PresentNumber], [PresentID], [Weight], [EnableSingleSell], [PayType], [DependentProducts], [Propority], [DeliverType], [DeliverCharge], [NeedInvoice], [Guarantee], [DeliverPayType], [ShopProductClassID], [OrderBy], [ShopProductCategoryID], [AutoPostBack], [Remark], [ProductClassName], [Province], [City], [ProductKind], [TemplateID], [SkinID], [Discount], [PresentMoney], [PresentPoint], [PresentExp], [Discount1], [PresentMoney1], [PresentPoint1], [PresentExp1], [Discount2], [PresentMoney2], [PresentPoint2], [PresentExp2], [Discount3], [PresentMoney3], [PresentPoint3], [PresentExp3], [CanTeam], [CanSee], [CanBuy], [TaxRate],[Color],[Size]) VALUES (@ShopID, @SalerID, @ChannelID, @ProductPlace, @ProductNum, @ClassID, @ProductName, @ProductModel, @ProductStandard, @ProducerName, @TrademarkName, @ProductIntro, @ProductExplain, @ProductImageUrl, @ProductSmallImageUrl, @UploadFiles, @StandPrice, @AuctionStartPrice, @ImcrementPrice, @CurrentPrice, @CurrentBidderID, @EmailSent, @BidTimes, @MemberPrice, @TeamName, @TeamNum, @TeamPrice1, @TempSubScriptionRate, @TeamNumber1, @TeamPrice2, @TeamNumber2, @TeamPrice3, @TeamNumber3, @TeamPrice4, @TeamNumber4, @TeamPrice5, @TeamNumber5, @TeamCurrentNumber1, @TeamCurrentNumber2, @TeamCurrentNumber3, @TeamCurrentNumber4, @TeamCurrentNumber5, @PUnit, @OnTop, @IsHot, @IsElite, @Stars, @Stocks, @OrderNum, @AlarmNum, @EnableSale, @BeginDate, @EndDate, @LimitNum, @Keyword, @CommentCount, @UpdateTime, @CreateTime, @Hits, @BuyTimes, @Inputer, @ValidDay, @SalePromotionType, @PresentNumber, @PresentID, @Weight, @EnableSingleSell, @PayType, @DependentProducts, @Propority, @DeliverType, @DeliverCharge, @NeedInvoice, @Guarantee, @DeliverPayType, @ShopProductClassID, @OrderBy, @ShopProductCategoryID, @AutoPostBack, @Remark, @ProductClassName, @Province, @City, @ProductKind, @TemplateID, @SkinID, @Discount, @PresentMoney, @PresentPoint, @PresentExp, @Discount1, @PresentMoney1, @PresentPoint1, @PresentExp1, @Discount2, @PresentMoney2, @PresentPoint2, @PresentExp2, @Discount3, @PresentMoney3, @PresentPoint3, @PresentExp3, @CanTeam, @CanSee, @CanBuy, @TaxRate,@Color,@Size)";
			this._adapter.InsertCommand.CommandType = CommandType.Text;
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@SalerID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "SalerID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ChannelID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ChannelID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ProductPlace", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ProductPlace", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ProductNum", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ProductNum", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ClassID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ClassID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ProductName", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ProductName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ProductModel", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ProductModel", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ProductStandard", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ProductStandard", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ProducerName", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ProducerName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TrademarkName", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "TrademarkName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ProductIntro", SqlDbType.Text, 0, ParameterDirection.Input, 0, 0, "ProductIntro", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ProductExplain", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "ProductExplain", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ProductImageUrl", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ProductImageUrl", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ProductSmallImageUrl", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ProductSmallImageUrl", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@UploadFiles", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "UploadFiles", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@StandPrice", SqlDbType.Decimal, 0, ParameterDirection.Input, 18, 2, "StandPrice", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@AuctionStartPrice", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "AuctionStartPrice", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ImcrementPrice", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "ImcrementPrice", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@CurrentPrice", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "CurrentPrice", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@CurrentBidderID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "CurrentBidderID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@EmailSent", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "EmailSent", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@BidTimes", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "BidTimes", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@MemberPrice", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "MemberPrice", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TeamName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "TeamName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TeamNum", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamNum", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TeamPrice1", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "TeamPrice1", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TempSubScriptionRate", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "TempSubScriptionRate", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TeamNumber1", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamNumber1", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TeamPrice2", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "TeamPrice2", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TeamNumber2", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamNumber2", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TeamPrice3", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "TeamPrice3", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TeamNumber3", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamNumber3", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TeamPrice4", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "TeamPrice4", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TeamNumber4", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamNumber4", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TeamPrice5", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "TeamPrice5", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TeamNumber5", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamNumber5", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TeamCurrentNumber1", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamCurrentNumber1", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TeamCurrentNumber2", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamCurrentNumber2", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TeamCurrentNumber3", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamCurrentNumber3", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TeamCurrentNumber4", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamCurrentNumber4", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TeamCurrentNumber5", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamCurrentNumber5", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PUnit", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "PUnit", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@OnTop", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "OnTop", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@IsHot", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "IsHot", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@IsElite", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "IsElite", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Stars", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Stars", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Stocks", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Stocks", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@OrderNum", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "OrderNum", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@AlarmNum", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "AlarmNum", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@EnableSale", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "EnableSale", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@BeginDate", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "BeginDate", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@EndDate", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "EndDate", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@LimitNum", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "LimitNum", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Keyword", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "Keyword", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@CommentCount", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "CommentCount", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@UpdateTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "UpdateTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@CreateTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "CreateTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Hits", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Hits", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@BuyTimes", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "BuyTimes", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Inputer", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Inputer", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ValidDay", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ValidDay", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@SalePromotionType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "SalePromotionType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PresentNumber", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentNumber", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PresentID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Weight", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Weight", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@EnableSingleSell", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "EnableSingleSell", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PayType", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "PayType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@DependentProducts", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "DependentProducts", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Propority", SqlDbType.Text, 0, ParameterDirection.Input, 0, 0, "Propority", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@DeliverType", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "DeliverType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@DeliverCharge", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "DeliverCharge", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@NeedInvoice", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "NeedInvoice", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Guarantee", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "Guarantee", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@DeliverPayType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "DeliverPayType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopProductClassID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopProductClassID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@OrderBy", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "OrderBy", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopProductCategoryID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopProductCategoryID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@AutoPostBack", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "AutoPostBack", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Remark", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "Remark", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ProductClassName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ProductClassName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Province", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Province", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@City", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "City", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ProductKind", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ProductKind", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TemplateID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TemplateID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@SkinID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "SkinID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Discount", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Discount", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PresentMoney", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "PresentMoney", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PresentPoint", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentPoint", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PresentExp", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentExp", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Discount1", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Discount1", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PresentMoney1", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "PresentMoney1", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PresentPoint1", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentPoint1", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PresentExp1", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentExp1", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Discount2", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Discount2", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PresentMoney2", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "PresentMoney2", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PresentPoint2", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentPoint2", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PresentExp2", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentExp2", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Discount3", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Discount3", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PresentMoney3", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "PresentMoney3", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PresentPoint3", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentPoint3", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PresentExp3", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentExp3", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@CanTeam", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "CanTeam", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@CanSee", SqlDbType.Char, 0, ParameterDirection.Input, 0, 0, "CanSee", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@CanBuy", SqlDbType.Char, 0, ParameterDirection.Input, 0, 0, "CanBuy", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TaxRate", SqlDbType.Decimal, 0, ParameterDirection.Input, 18, 0, "TaxRate", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Color", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Color", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Size", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Size", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand = new SqlCommand();
			this._adapter.UpdateCommand.Connection = this.Connection;
			this._adapter.UpdateCommand.CommandText = "UPDATE [HLShop_Product] SET [ShopID] = @ShopID, [SalerID] = @SalerID, [ChannelID] = @ChannelID, [ProductPlace] = @ProductPlace, [ProductNum] = @ProductNum, [ClassID] = @ClassID, [ProductName] = @ProductName, [ProductModel] = @ProductModel, [ProductStandard] = @ProductStandard, [ProducerName] = @ProducerName, [TrademarkName] = @TrademarkName, [ProductIntro] = @ProductIntro, [ProductExplain] = @ProductExplain, [ProductImageUrl] = @ProductImageUrl, [ProductSmallImageUrl] = @ProductSmallImageUrl, [UploadFiles] = @UploadFiles, [StandPrice] = @StandPrice, [AuctionStartPrice] = @AuctionStartPrice, [ImcrementPrice] = @ImcrementPrice, [CurrentPrice] = @CurrentPrice, [CurrentBidderID] = @CurrentBidderID, [EmailSent] = @EmailSent, [BidTimes] = @BidTimes, [MemberPrice] = @MemberPrice, [TeamName] = @TeamName, [TeamNum] = @TeamNum, [TeamPrice1] = @TeamPrice1, [TempSubScriptionRate] = @TempSubScriptionRate, [TeamNumber1] = @TeamNumber1, [TeamPrice2] = @TeamPrice2, [TeamNumber2] = @TeamNumber2, [TeamPrice3] = @TeamPrice3, [TeamNumber3] = @TeamNumber3, [TeamPrice4] = @TeamPrice4, [TeamNumber4] = @TeamNumber4, [TeamPrice5] = @TeamPrice5, [TeamNumber5] = @TeamNumber5, [TeamCurrentNumber1] = @TeamCurrentNumber1, [TeamCurrentNumber2] = @TeamCurrentNumber2, [TeamCurrentNumber3] = @TeamCurrentNumber3, [TeamCurrentNumber4] = @TeamCurrentNumber4, [TeamCurrentNumber5] = @TeamCurrentNumber5, [PUnit] = @PUnit, [OnTop] = @OnTop, [IsHot] = @IsHot, [IsElite] = @IsElite, [Stars] = @Stars, [Stocks] = @Stocks, [OrderNum] = @OrderNum, [AlarmNum] = @AlarmNum, [EnableSale] = @EnableSale, [BeginDate] = @BeginDate, [EndDate] = @EndDate, [LimitNum] = @LimitNum, [Keyword] = @Keyword, [CommentCount] = @CommentCount, [UpdateTime] = @UpdateTime, [CreateTime] = @CreateTime, [Hits] = @Hits, [BuyTimes] = @BuyTimes, [Inputer] = @Inputer, [ValidDay] = @ValidDay, [SalePromotionType] = @SalePromotionType, [PresentNumber] = @PresentNumber, [PresentID] = @PresentID, [Weight] = @Weight, [EnableSingleSell] = @EnableSingleSell, [PayType] = @PayType, [DependentProducts] = @DependentProducts, [Propority] = @Propority, [DeliverType] = @DeliverType, [DeliverCharge] = @DeliverCharge, [NeedInvoice] = @NeedInvoice, [Guarantee] = @Guarantee, [DeliverPayType] = @DeliverPayType, [ShopProductClassID] = @ShopProductClassID, [OrderBy] = @OrderBy, [ShopProductCategoryID] = @ShopProductCategoryID, [AutoPostBack] = @AutoPostBack, [Remark] = @Remark, [ProductClassName] = @ProductClassName, [Province] = @Province, [City] = @City, [ProductKind] = @ProductKind, [TemplateID] = @TemplateID, [SkinID] = @SkinID, [Discount] = @Discount, [PresentMoney] = @PresentMoney, [PresentPoint] = @PresentPoint, [PresentExp] = @PresentExp, [Discount1] = @Discount1, [PresentMoney1] = @PresentMoney1, [PresentPoint1] = @PresentPoint1, [PresentExp1] = @PresentExp1, [Discount2] = @Discount2, [PresentMoney2] = @PresentMoney2, [PresentPoint2] = @PresentPoint2, [PresentExp2] = @PresentExp2, [Discount3] = @Discount3, [PresentMoney3] = @PresentMoney3, [PresentPoint3] = @PresentPoint3, [PresentExp3] = @PresentExp3, [CanTeam] = @CanTeam, [CanSee] = @CanSee, [CanBuy] = @CanBuy, [TaxRate] = @TaxRate,[Color] = @Color,[Size] = @Size,[Attributes]=@Attributes,[CustomPrice]=@CustomPrice,[IntegraUse]=@IntegraUse WHERE (([ProductID] = @Original_ProductID))";
			this._adapter.UpdateCommand.CommandType = CommandType.Text;
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@SalerID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "SalerID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ChannelID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ChannelID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ProductPlace", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ProductPlace", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ProductNum", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ProductNum", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ClassID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ClassID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ProductName", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ProductName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ProductModel", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ProductModel", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ProductStandard", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ProductStandard", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ProducerName", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ProducerName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TrademarkName", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "TrademarkName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ProductIntro", SqlDbType.Text, 0, ParameterDirection.Input, 0, 0, "ProductIntro", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ProductExplain", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "ProductExplain", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ProductImageUrl", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ProductImageUrl", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ProductSmallImageUrl", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ProductSmallImageUrl", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@UploadFiles", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "UploadFiles", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@StandPrice", SqlDbType.Decimal, 0, ParameterDirection.Input, 18, 2, "StandPrice", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@AuctionStartPrice", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "AuctionStartPrice", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ImcrementPrice", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "ImcrementPrice", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@CurrentPrice", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "CurrentPrice", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@CurrentBidderID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "CurrentBidderID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@EmailSent", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "EmailSent", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@BidTimes", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "BidTimes", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@MemberPrice", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "MemberPrice", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TeamName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "TeamName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TeamNum", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamNum", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TeamPrice1", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "TeamPrice1", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TempSubScriptionRate", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "TempSubScriptionRate", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TeamNumber1", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamNumber1", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TeamPrice2", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "TeamPrice2", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TeamNumber2", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamNumber2", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TeamPrice3", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "TeamPrice3", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TeamNumber3", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamNumber3", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TeamPrice4", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "TeamPrice4", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TeamNumber4", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamNumber4", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TeamPrice5", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "TeamPrice5", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TeamNumber5", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamNumber5", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TeamCurrentNumber1", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamCurrentNumber1", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TeamCurrentNumber2", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamCurrentNumber2", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TeamCurrentNumber3", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamCurrentNumber3", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TeamCurrentNumber4", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamCurrentNumber4", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TeamCurrentNumber5", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamCurrentNumber5", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PUnit", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "PUnit", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@OnTop", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "OnTop", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@IsHot", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "IsHot", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@IsElite", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "IsElite", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Stars", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Stars", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Stocks", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Stocks", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@OrderNum", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "OrderNum", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@AlarmNum", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "AlarmNum", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@EnableSale", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "EnableSale", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@BeginDate", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "BeginDate", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@EndDate", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "EndDate", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@LimitNum", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "LimitNum", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Keyword", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "Keyword", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@CommentCount", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "CommentCount", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@UpdateTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "UpdateTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@CreateTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "CreateTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Hits", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Hits", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@BuyTimes", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "BuyTimes", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Inputer", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Inputer", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ValidDay", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ValidDay", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@SalePromotionType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "SalePromotionType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PresentNumber", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentNumber", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PresentID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Weight", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Weight", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@EnableSingleSell", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "EnableSingleSell", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PayType", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "PayType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@DependentProducts", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "DependentProducts", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Propority", SqlDbType.Text, 0, ParameterDirection.Input, 0, 0, "Propority", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@DeliverType", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "DeliverType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@DeliverCharge", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "DeliverCharge", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@NeedInvoice", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "NeedInvoice", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Guarantee", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "Guarantee", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@DeliverPayType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "DeliverPayType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopProductClassID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopProductClassID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@OrderBy", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "OrderBy", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopProductCategoryID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopProductCategoryID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@AutoPostBack", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "AutoPostBack", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Remark", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "Remark", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ProductClassName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ProductClassName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Province", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Province", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@City", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "City", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ProductKind", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ProductKind", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TemplateID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TemplateID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@SkinID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "SkinID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Discount", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Discount", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PresentMoney", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "PresentMoney", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PresentPoint", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentPoint", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PresentExp", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentExp", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Discount1", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Discount1", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PresentMoney1", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "PresentMoney1", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PresentPoint1", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentPoint1", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PresentExp1", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentExp1", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Discount2", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Discount2", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PresentMoney2", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "PresentMoney2", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PresentPoint2", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentPoint2", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PresentExp2", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentExp2", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Discount3", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Discount3", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PresentMoney3", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "PresentMoney3", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PresentPoint3", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentPoint3", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PresentExp3", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentExp3", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@CanTeam", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "CanTeam", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@CanSee", SqlDbType.Char, 0, ParameterDirection.Input, 0, 0, "CanSee", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@CanBuy", SqlDbType.Char, 0, ParameterDirection.Input, 0, 0, "CanBuy", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TaxRate", SqlDbType.Decimal, 0, ParameterDirection.Input, 18, 0, "TaxRate", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Original_ProductID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Original, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Color", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Color", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Size", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Size", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Attributes", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Attributes", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@CustomPrice", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "CustomPrice", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@IntegraUse", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "IntegraUse", DataRowVersion.Current, false, null, "", "", ""));
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitConnection()
		{
			this._connection = new SqlConnection();
			this._connection.ConnectionString = Conn.CurrenConnectionStrings;
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitCommandCollection()
		{
			this._commandCollection = new SqlCommand[36];
			this._commandCollection[0] = new SqlCommand();
			this._commandCollection[0].Connection = this.Connection;
			this._commandCollection[0].CommandText = "SELECT ProductID, ShopID, SalerID, ChannelID, ProductPlace, ProductNum, ClassID, ProductName, ProductModel, ProductStandard, ProducerName, TrademarkName, ProductIntro, ProductExplain, ProductImageUrl, ProductSmallImageUrl, UploadFiles, StandPrice, AuctionStartPrice, ImcrementPrice, CurrentPrice, CurrentBidderID, EmailSent, BidTimes, MemberPrice, TeamName, TeamNum, TeamPrice1, TempSubScriptionRate, TeamNumber1, TeamPrice2, TeamNumber2, TeamPrice3, TeamNumber3, TeamPrice4, TeamNumber4, TeamPrice5, TeamNumber5, TeamCurrentNumber1, TeamCurrentNumber2, TeamCurrentNumber3, TeamCurrentNumber4, TeamCurrentNumber5, PUnit, OnTop, IsHot, IsElite, Stars, Stocks, OrderNum, AlarmNum, EnableSale, BeginDate, EndDate, LimitNum, Keyword, CommentCount, UpdateTime, CreateTime, Hits, BuyTimes, Inputer, ValidDay, SalePromotionType, PresentNumber, PresentID, Weight, EnableSingleSell, PayType, DependentProducts, Propority, DeliverType, DeliverCharge, NeedInvoice, Guarantee, DeliverPayType, ShopProductClassID, OrderBy, ShopProductCategoryID, AutoPostBack, Remark, ProductClassName, Province, City, ProductKind, TemplateID, SkinID, Discount, PresentMoney, PresentPoint, PresentExp, Discount1, PresentMoney1, PresentPoint1, PresentExp1, Discount2, PresentMoney2, PresentPoint2, PresentExp2, Discount3, PresentMoney3, PresentPoint3, PresentExp3, CanTeam, CanSee, CanBuy, TaxRate FROM HLShop_Product";
			this._commandCollection[0].CommandType = CommandType.Text;
			this._commandCollection[1] = new SqlCommand();
			this._commandCollection[1].Connection = this.Connection;
			this._commandCollection[1].CommandText = "PR_AddProduct";
			this._commandCollection[1].CommandType = CommandType.StoredProcedure;
			this._commandCollection[1].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ShopID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@SalerID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ChannelID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ProductPlace", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ProductNum", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ClassID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ProductName", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ProductModel", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ProductStandard", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ProducerName", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TrademarkName", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ProductIntro", SqlDbType.Text, 2147483647, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ProductImageUrl", SqlDbType.VarChar, 200, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ProductType", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@StandPrice", SqlDbType.Decimal, 9, ParameterDirection.Input, 18, 2, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@AuctionStartPrice", SqlDbType.Decimal, 9, ParameterDirection.Input, 18, 2, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ImcrementPrice", SqlDbType.Decimal, 9, ParameterDirection.Input, 18, 2, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@MemberPrice", SqlDbType.Decimal, 9, ParameterDirection.Input, 18, 2, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TeamName", SqlDbType.VarChar, 200, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TeamNum", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TeamPrice1", SqlDbType.Decimal, 9, ParameterDirection.Input, 18, 2, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TempSubScriptionRate", SqlDbType.Decimal, 9, ParameterDirection.Input, 18, 2, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TeamNumber1", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TeamPrice2", SqlDbType.Decimal, 9, ParameterDirection.Input, 18, 2, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TeamNumber2", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TeamPrice3", SqlDbType.Decimal, 9, ParameterDirection.Input, 18, 2, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TeamNumber3", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TeamPrice4", SqlDbType.Decimal, 9, ParameterDirection.Input, 18, 2, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TeamNumber4", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TeamPrice5", SqlDbType.Decimal, 9, ParameterDirection.Input, 18, 2, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TeamNumber5", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@IsElite", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Stocks", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@EnableSale", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Keyword", SqlDbType.NText, 1073741823, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Inputer", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@SalePromotionType", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Weight", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Propority", SqlDbType.Text, 2147483647, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@DeliverType", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@DeliverCharge", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@NeedInvoice", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Guarantee", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ValidDay", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@AutoPostBack", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Remark", SqlDbType.VarChar, 500, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@DeliverPayType", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@OnlinePayType", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@PayType", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Hits", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@BuyTimes", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@OnTop", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@IsHot", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Stars", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@BeginDate", SqlDbType.DateTime, 8, ParameterDirection.Input, 23, 3, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@EndDate", SqlDbType.DateTime, 8, ParameterDirection.Input, 23, 3, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@LimitNum", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@EnableSingleSell", SqlDbType.Bit, 1, ParameterDirection.Input, 1, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TemplateID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@SkinID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Discount", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@PresentExp", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@PresentPoint", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@PresentMoney", SqlDbType.Decimal, 9, ParameterDirection.Input, 18, 2, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Discount1", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@PresentExp1", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@PresentPoint1", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@PresentMoney1", SqlDbType.Decimal, 9, ParameterDirection.Input, 18, 2, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Discount2", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@PresentExp2", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@PresentPoint2", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@PresentMoney2", SqlDbType.Decimal, 9, ParameterDirection.Input, 18, 2, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@Discount3", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@PresentExp3", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@PresentPoint3", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@PresentMoney3", SqlDbType.Decimal, 9, ParameterDirection.Input, 18, 2, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@PUnit", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@ProductSmallImageUrl", SqlDbType.VarChar, 200, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@TaxRate", SqlDbType.Decimal, 9, ParameterDirection.Input, 18, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@UploadFiles", SqlDbType.Text, 2147483647, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2] = new SqlCommand();
			this._commandCollection[2].Connection = this.Connection;
			this._commandCollection[2].CommandText = "pr_EditProductByProductID";
			this._commandCollection[2].CommandType = CommandType.StoredProcedure;
			this._commandCollection[2].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.VarChar, 300, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2].Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[3] = new SqlCommand();
			this._commandCollection[3].Connection = this.Connection;
			this._commandCollection[3].CommandText = "PR_AdminProductClassStatistics";
			this._commandCollection[3].CommandType = CommandType.StoredProcedure;
			this._commandCollection[3].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[4] = new SqlCommand();
			this._commandCollection[4].Connection = this.Connection;
			this._commandCollection[4].CommandText = "SELECT AlarmNum, AuctionStartPrice, AutoPostBack, BeginDate, BidTimes, BuyTimes, CanBuy, CanSee, CanTeam, ChannelID, City, ClassID, CommentCount, CreateTime, CurrentBidderID, CurrentPrice, DeliverCharge, DeliverPayType, DeliverType, DependentProducts, Discount, Discount1, Discount2, Discount3, EmailSent, EnableSale, EnableSingleSell, EndDate, Guarantee, Hits, ImcrementPrice, Inputer, IsElite, IsHot, Keyword, LeftTime, LimitNum, MemberPrice, NeedInvoice, OnTop, OrderBy, OrderNum, PUnit, PayType, PresentExp, PresentExp1, PresentExp2, PresentExp3, PresentID, PresentMoney, PresentMoney1, PresentMoney2, PresentMoney3, PresentNumber, PresentPoint, PresentPoint1, PresentPoint2, PresentPoint3, ProducerName, ProductClassName, ProductExplain, ProductID, ProductImageUrl, ProductIntro, ProductKind, ProductModel, ProductName, ProductNum, ProductPlace, ProductSmallImageUrl, ProductStandard, Propority, Province, Remark, SalePromotionType, SalerID, ShopID, ShopProductCategoryID, ShopProductClassID, SkinID, StandPrice, Stars, Stocks, TaxRate, TeamCurrentNumber1, TeamCurrentNumber2, TeamCurrentNumber3, TeamCurrentNumber4, TeamCurrentNumber5, TeamName, TeamNum, TeamNumber1, TeamNumber2, TeamNumber3, TeamNumber4, TeamNumber5, TeamPrice1, TeamPrice2, TeamPrice3, TeamPrice4, TeamPrice5, TempSubScriptionRate, TemplateID, TrademarkName, UpdateTime, UploadFiles, ValidDay, Weight FROM HLShop_Product WHERE (ProductID = @ProductID)";
			this._commandCollection[4].CommandType = CommandType.Text;
			this._commandCollection[4].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[5] = new SqlCommand();
			this._commandCollection[5].Connection = this.Connection;
			this._commandCollection[5].CommandText = "PR_GetAuctionProductByProductID";
			this._commandCollection[5].CommandType = CommandType.StoredProcedure;
			this._commandCollection[5].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[5].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[6] = new SqlCommand();
			this._commandCollection[6].Connection = this.Connection;
			this._commandCollection[6].CommandText = "pr_GetProductsOnSaleBySalerID";
			this._commandCollection[6].CommandType = CommandType.StoredProcedure;
			this._commandCollection[6].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[6].Parameters.Add(new SqlParameter("@SalerID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[7] = new SqlCommand();
			this._commandCollection[7].Connection = this.Connection;
			this._commandCollection[7].CommandText = "Pr_GetProductByCategoryIDShopIDKeywords";
			this._commandCollection[7].CommandType = CommandType.StoredProcedure;
			this._commandCollection[7].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[7].Parameters.Add(new SqlParameter("@CateGoryID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[7].Parameters.Add(new SqlParameter("@ShopID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[7].Parameters.Add(new SqlParameter("@Keywords", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[7].Parameters.Add(new SqlParameter("@DateTimeSect", SqlDbType.VarChar, 10, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8] = new SqlCommand();
			this._commandCollection[8].Connection = this.Connection;
			this._commandCollection[8].CommandText = "\r\n                      SELECT CASE WHEN ProductType = '一口价' THEN StandPrice WHEN ProductType = '团购' THEN\r\n                      TeamPrice1 ELSE AuctionStartPrice END AS ProductPrice,\r\n                      CASE WHEN ProductType = '团购' THEN TeamNumber5 - TeamCurrentNumber5 END AS\r\n                      LeftPeople, DATEDIFF(s, GETDATE(), HLShop_Product.EndDate) AS LeftTime,\r\n                      HLShop_Product.BeginDate, HLShop_Product.ClassID, HLShop_Product.Hits,\r\n                      HLShop_Product.ProductID, HLShop_Product.ProductImageUrl, HLShop_Product.ProductSmallImageUrl,\r\n                      HLShop_Product.ProductName, HLShop_Product.ProductPlace,\r\n                      HLShop_Product.ProductType, HLShop_Product.SalerID, HL_UserInfo.OICQ,\r\n                      HL_UserInfo.Taobaowangwang,\r\n                      (SELECT UserName\r\n                      FROM HL_User\r\n                      WHERE (UserID = HLShop_Product.SalerID)) AS ShopOwnerName,\r\n                      HLShop_Product.Keyword, HLShop_Product.ProductStandard\r\n                      FROM HLShop_Product INNER JOIN\r\n                      HL_UserInfo ON HLShop_Product.SalerID = HL_UserInfo.UserID\r\n                      WHERE (HLShop_Product.ClassID = @ParentID) AND\r\n                      (HLShop_Product.EndDate >= GETDATE()) and  HLShop_Product.EnableSale=1 And HLShop_Product.EnableSingleSell=1";
			this._commandCollection[8].CommandType = CommandType.Text;
			this._commandCollection[8].Parameters.Add(new SqlParameter("@ParentID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ClassID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9] = new SqlCommand();
			this._commandCollection[9].Connection = this.Connection;
			this._commandCollection[9].CommandText = "SELECT AlarmNum, AuctionStartPrice, AutoPostBack, BeginDate, BidTimes, BuyTimes, CanBuy, CanSee, CanTeam, ChannelID, City, ClassID, CommentCount, CreateTime, CurrentBidderID, CurrentPrice, DeliverCharge, DeliverPayType, DeliverType, DependentProducts, Discount, Discount1, Discount2, Discount3, EmailSent, EnableSale, EnableSingleSell, EndDate, Guarantee, Hits, ImcrementPrice, Inputer, IsElite, IsHot, Keyword, LeftTime, LimitNum, MemberPrice, NeedInvoice, OnTop, OrderBy, OrderNum, PUnit, PayType, PresentExp, PresentExp1, PresentExp2, PresentExp3, PresentID, PresentMoney, PresentMoney1, PresentMoney2, PresentMoney3, PresentNumber, PresentPoint, PresentPoint1, PresentPoint2, PresentPoint3, ProducerName, ProductClassName, ProductExplain, ProductID, ProductImageUrl, ProductIntro, ProductKind, ProductModel, ProductName, ProductNum, ProductPlace, ProductSmallImageUrl, ProductStandard, Propority, Province, Remark, SalePromotionType, SalerID, ShopID, ShopProductCategoryID, ShopProductClassID, SkinID, StandPrice, Stars, Stocks, TaxRate, TeamCurrentNumber1, TeamCurrentNumber2, TeamCurrentNumber3, TeamCurrentNumber4, TeamCurrentNumber5, TeamName, TeamNum, TeamNumber1, TeamNumber2, TeamNumber3, TeamNumber4, TeamNumber5, TeamPrice1, TeamPrice2, TeamPrice3, TeamPrice4, TeamPrice5, TempSubScriptionRate, TemplateID, TrademarkName, UpdateTime, UploadFiles, ValidDay, Weight FROM HLShop_Product WHERE (ProducerName = @ProducerName)";
			this._commandCollection[9].CommandType = CommandType.Text;
			this._commandCollection[9].Parameters.Add(new SqlParameter("@ProducerName", SqlDbType.NVarChar, 50, ParameterDirection.Input, 0, 0, "ProducerName", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[10] = new SqlCommand();
			this._commandCollection[10].Connection = this.Connection;
			this._commandCollection[10].CommandText = "\r\n                      SELECT DATEDIFF(s, GETDATE(), HLShop_Product.EndDate) AS LeftTime,HLShop_Product.*,\r\n                      HL_User.UserName AS salername\r\n                      FROM HLShop_Product INNER JOIN\r\n                      HL_User ON HLShop_Product.SalerID = HL_User.UserID\r\n                      WHERE (HLShop_Product.ProductID = @ProductID)";
			this._commandCollection[10].CommandType = CommandType.Text;
			this._commandCollection[10].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[11] = new SqlCommand();
			this._commandCollection[11].Connection = this.Connection;
			this._commandCollection[11].CommandText = "Pr_GetProductBySalerIDNameType";
			this._commandCollection[11].CommandType = CommandType.StoredProcedure;
			this._commandCollection[11].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[11].Parameters.Add(new SqlParameter("@SalerID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[11].Parameters.Add(new SqlParameter("@ProductName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[11].Parameters.Add(new SqlParameter("@ProductType", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[12] = new SqlCommand();
			this._commandCollection[12].Connection = this.Connection;
			this._commandCollection[12].CommandText = "pr_GetProductByShopCategoryID";
			this._commandCollection[12].CommandType = CommandType.StoredProcedure;
			this._commandCollection[12].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[12].Parameters.Add(new SqlParameter("@shopid", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[12].Parameters.Add(new SqlParameter("@ShopProductClassID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[12].Parameters.Add(new SqlParameter("@KeyWords", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13] = new SqlCommand();
			this._commandCollection[13].Connection = this.Connection;
			this._commandCollection[13].CommandText = "SELECT AlarmNum, AuctionStartPrice, AutoPostBack, BeginDate, BidTimes, BuyTimes, CanBuy, CanSee, CanTeam, ChannelID, City, ClassID, CommentCount, CreateTime, CurrentBidderID, CurrentPrice, DeliverCharge, DeliverPayType, DeliverType, DependentProducts, Discount, Discount1, Discount2, Discount3, EmailSent, EnableSale, EnableSingleSell, EndDate, Guarantee, Hits, ImcrementPrice, Inputer, IsElite, IsHot, Keyword, LeftTime, LimitNum, MemberPrice, NeedInvoice, OnTop, OrderBy, OrderNum, PUnit, PayType, PresentExp, PresentExp1, PresentExp2, PresentExp3, PresentID, PresentMoney, PresentMoney1, PresentMoney2, PresentMoney3, PresentNumber, PresentPoint, PresentPoint1, PresentPoint2, PresentPoint3, ProducerName, ProductClassName, ProductExplain, ProductID, ProductImageUrl, ProductIntro, ProductKind, ProductModel, ProductName, ProductNum, ProductPlace, ProductSmallImageUrl, ProductStandard, Propority, Province, Remark, SalePromotionType, SalerID, ShopID, ShopProductCategoryID, ShopProductClassID, SkinID, StandPrice, Stars, Stocks, TaxRate, TeamCurrentNumber1, TeamCurrentNumber2, TeamCurrentNumber3, TeamCurrentNumber4, TeamCurrentNumber5, TeamName, TeamNum, TeamNumber1, TeamNumber2, TeamNumber3, TeamNumber4, TeamNumber5, TeamPrice1, TeamPrice2, TeamPrice3, TeamPrice4, TeamPrice5, TempSubScriptionRate, TemplateID, TrademarkName, UpdateTime, UploadFiles, ValidDay, Weight FROM HLShop_Product WHERE (ShopID = @ShopID) AND (ProducerName LIKE '%' + @ProducerName + '%') AND (ProductType = @ProductType)";
			this._commandCollection[13].CommandType = CommandType.Text;
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ShopID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ShopID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ProducerName", SqlDbType.NVarChar, 50, ParameterDirection.Input, 0, 0, "ProducerName", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ProductType", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "ProductType", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14] = new SqlCommand();
			this._commandCollection[14].Connection = this.Connection;
			this._commandCollection[14].CommandText = "SELECT COUNT(*) AS Expr1\r\nFROM HLShop_Product\r\nWHERE (ProductImageUrl = @filepath) OR\r\n      (ProductSmallImageUrl = @filepath)";
			this._commandCollection[14].CommandType = CommandType.Text;
			this._commandCollection[14].Parameters.Add(new SqlParameter("@filepath", SqlDbType.VarChar, 200, ParameterDirection.Input, 0, 0, "ProductImageUrl", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15] = new SqlCommand();
			this._commandCollection[15].Connection = this.Connection;
			this._commandCollection[15].CommandText = "SELECT COUNT(ProductID)As ProductID FROM HLShop_Product";
			this._commandCollection[15].CommandType = CommandType.Text;
			this._commandCollection[16] = new SqlCommand();
			this._commandCollection[16].Connection = this.Connection;
			this._commandCollection[16].CommandText = "pr_GetProductInStock";
			this._commandCollection[16].CommandType = CommandType.StoredProcedure;
			this._commandCollection[16].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16].Parameters.Add(new SqlParameter("@SalerID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16].Parameters.Add(new SqlParameter("@StockType", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[17] = new SqlCommand();
			this._commandCollection[17].Connection = this.Connection;
			this._commandCollection[17].CommandText = "pr_GetProductIsOnTopOrHot";
			this._commandCollection[17].CommandType = CommandType.StoredProcedure;
			this._commandCollection[17].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[17].Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18] = new SqlCommand();
			this._commandCollection[18].Connection = this.Connection;
			this._commandCollection[18].CommandText = "pr_GetProductIsOnTopOrHotClassID";
			this._commandCollection[18].CommandType = CommandType.StoredProcedure;
			this._commandCollection[18].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18].Parameters.Add(new SqlParameter("@Type", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18].Parameters.Add(new SqlParameter("@ClassID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[19] = new SqlCommand();
			this._commandCollection[19].Connection = this.Connection;
			this._commandCollection[19].CommandText = "PR_Page";
			this._commandCollection[19].CommandType = CommandType.StoredProcedure;
			this._commandCollection[19].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[19].Parameters.Add(new SqlParameter("@tblName", SqlDbType.VarChar, 255, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[19].Parameters.Add(new SqlParameter("@strGetFields", SqlDbType.VarChar, 1000, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[19].Parameters.Add(new SqlParameter("@fldName", SqlDbType.VarChar, 255, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[19].Parameters.Add(new SqlParameter("@PageSize", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[19].Parameters.Add(new SqlParameter("@PageIndex", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[19].Parameters.Add(new SqlParameter("@OrderType", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[19].Parameters.Add(new SqlParameter("@strWhere", SqlDbType.VarChar, 1500, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[19].Parameters.Add(new SqlParameter("@Counts", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[20] = new SqlCommand();
			this._commandCollection[20].Connection = this.Connection;
			this._commandCollection[20].CommandText = "SELECT AlarmNum, AuctionStartPrice, AutoPostBack, BeginDate, BidTimes, BuyTimes, CanBuy, CanSee, CanTeam, ChannelID, City, ClassID, CommentCount, CreateTime, CurrentBidderID, CurrentPrice, DeliverCharge, DeliverPayType, DeliverType, DependentProducts, Discount, Discount1, Discount2, Discount3, EmailSent, EnableSale, EnableSingleSell, EndDate, Guarantee, Hits, ImcrementPrice, Inputer, IsElite, IsHot, Keyword, LeftTime, LimitNum, MemberPrice, NeedInvoice, OnTop, OrderBy, OrderNum, PUnit, PayType, PresentExp, PresentExp1, PresentExp2, PresentExp3, PresentID, PresentMoney, PresentMoney1, PresentMoney2, PresentMoney3, PresentNumber, PresentPoint, PresentPoint1, PresentPoint2, PresentPoint3, ProducerName, ProductClassName, ProductExplain, ProductID, ProductImageUrl, ProductIntro, ProductKind, ProductModel, ProductName, ProductNum, ProductPlace, ProductSmallImageUrl, ProductStandard, Propority, Province, Remark, SalePromotionType, SalerID, ShopID, ShopProductCategoryID, ShopProductClassID, SkinID, StandPrice, Stars, Stocks, TaxRate, TeamCurrentNumber1, TeamCurrentNumber2, TeamCurrentNumber3, TeamCurrentNumber4, TeamCurrentNumber5, TeamName, TeamNum, TeamNumber1, TeamNumber2, TeamNumber3, TeamNumber4, TeamNumber5, TeamPrice1, TeamPrice2, TeamPrice3, TeamPrice4, TeamPrice5, TempSubScriptionRate, TemplateID, TrademarkName, UpdateTime, UploadFiles, ValidDay, Weight FROM HLShop_Product WHERE (ProductPlace = @ProductPlace)";
			this._commandCollection[20].CommandType = CommandType.Text;
			this._commandCollection[20].Parameters.Add(new SqlParameter("@ProductPlace", SqlDbType.NVarChar, 50, ParameterDirection.Input, 0, 0, "ProductPlace", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[21] = new SqlCommand();
			this._commandCollection[21].Connection = this.Connection;
			this._commandCollection[21].CommandText = "SELECT AlarmNum, AuctionStartPrice, AutoPostBack, BeginDate, BidTimes, BuyTimes, CanBuy, CanSee, CanTeam, ChannelID, City, ClassID, CommentCount, CreateTime, CurrentBidderID, CurrentPrice, DeliverCharge, DeliverPayType, DeliverType, DependentProducts, Discount, Discount1, Discount2, Discount3, EmailSent, EnableSale, EnableSingleSell, EndDate, Guarantee, Hits, ImcrementPrice, Inputer, IsElite, IsHot, Keyword, LeftTime, LimitNum, MemberPrice, NeedInvoice, OnTop, OrderBy, OrderNum, PUnit, PayType, PresentExp, PresentExp1, PresentExp2, PresentExp3, PresentID, PresentMoney, PresentMoney1, PresentMoney2, PresentMoney3, PresentNumber, PresentPoint, PresentPoint1, PresentPoint2, PresentPoint3, ProducerName, ProductClassName, ProductExplain, ProductID, ProductImageUrl, ProductIntro, ProductKind, ProductModel, ProductName, ProductNum, ProductPlace, ProductSmallImageUrl, ProductStandard, Propority, Province, Remark, SalePromotionType, SalerID, ShopID, ShopProductCategoryID, ShopProductClassID, SkinID, StandPrice, Stars, Stocks, TaxRate, TeamCurrentNumber1, TeamCurrentNumber2, TeamCurrentNumber3, TeamCurrentNumber4, TeamCurrentNumber5, TeamName, TeamNum, TeamNumber1, TeamNumber2, TeamNumber3, TeamNumber4, TeamNumber5, TeamPrice1, TeamPrice2, TeamPrice3, TeamPrice4, TeamPrice5, TempSubScriptionRate, TemplateID, TrademarkName, UpdateTime, UploadFiles, ValidDay, Weight FROM HLShop_Product WHERE (ProductType = @ProductType)";
			this._commandCollection[21].CommandType = CommandType.Text;
			this._commandCollection[21].Parameters.Add(new SqlParameter("@ProductType", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "ProductType", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[22] = new SqlCommand();
			this._commandCollection[22].Connection = this.Connection;
			this._commandCollection[22].CommandText = "pr_GetProductsForCompare";
			this._commandCollection[22].CommandType = CommandType.StoredProcedure;
			this._commandCollection[22].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[22].Parameters.Add(new SqlParameter("@ProductID_Array", SqlDbType.VarChar, 300, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[23] = new SqlCommand();
			this._commandCollection[23].Connection = this.Connection;
			this._commandCollection[23].CommandText = "pr_GetRecommendProductBySalerID";
			this._commandCollection[23].CommandType = CommandType.StoredProcedure;
			this._commandCollection[23].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[23].Parameters.Add(new SqlParameter("@SalerID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[24] = new SqlCommand();
			this._commandCollection[24].Connection = this.Connection;
			this._commandCollection[24].CommandText = "Pr_GetShopUploadProductFile";
			this._commandCollection[24].CommandType = CommandType.StoredProcedure;
			this._commandCollection[24].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[24].Parameters.Add(new SqlParameter("@NickName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[24].Parameters.Add(new SqlParameter("@UploadFileName", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[24].Parameters.Add(new SqlParameter("@U_Identify", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[25] = new SqlCommand();
			this._commandCollection[25].Connection = this.Connection;
			this._commandCollection[25].CommandText = "SELECT TOP 5 AlarmNum, AuctionStartPrice, AutoPostBack, BeginDate, BidTimes, BuyTimes, CanBuy, CanSee, CanTeam, ChannelID, City, ClassID, CommentCount, CreateTime, CurrentBidderID, CurrentPrice, DeliverCharge, DeliverPayType, DeliverType, DependentProducts, Discount, Discount1, Discount2, Discount3, EmailSent, EnableSale, EnableSingleSell, EndDate, Guarantee, Hits, ImcrementPrice, Inputer, IsElite, IsHot, Keyword, LeftTime, LimitNum, MemberPrice, NeedInvoice, OnTop, OrderBy, OrderNum, PUnit, PayType, PresentExp, PresentExp1, PresentExp2, PresentExp3, PresentID, PresentMoney, PresentMoney1, PresentMoney2, PresentMoney3, PresentNumber, PresentPoint, PresentPoint1, PresentPoint2, PresentPoint3, ProducerName, ProductClassName, ProductExplain, ProductID, ProductImageUrl, ProductIntro, ProductKind, ProductModel, ProductName, ProductNum, ProductPlace, ProductSmallImageUrl, ProductStandard, Propority, Province, Remark, SalePromotionType, SalerID, ShopID, ShopProductCategoryID, ShopProductClassID, SkinID, StandPrice, Stars, Stocks, TaxRate, TeamCurrentNumber1, TeamCurrentNumber2, TeamCurrentNumber3, TeamCurrentNumber4, TeamCurrentNumber5, TeamName, TeamNum, TeamNumber1, TeamNumber2, TeamNumber3, TeamNumber4, TeamNumber5, TeamPrice1, TeamPrice2, TeamPrice3, TeamPrice4, TeamPrice5, TempSubScriptionRate, TemplateID, TrademarkName, UpdateTime, UploadFiles, ValidDay, Weight FROM HLShop_Product WHERE (ShopID = @ShopID) AND (IsElite = 1) ORDER BY ProductID DESC";
			this._commandCollection[25].CommandType = CommandType.Text;
			this._commandCollection[25].Parameters.Add(new SqlParameter("@ShopID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ShopID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[26] = new SqlCommand();
			this._commandCollection[26].Connection = this.Connection;
			this._commandCollection[26].CommandText = "UPDATE HLShop_Product\r\nSET ShopProductCategoryID =0\r\nWHERE (ShopProductCategoryID = @ShopProductCategoryID)";
			this._commandCollection[26].CommandType = CommandType.Text;
			this._commandCollection[26].Parameters.Add(new SqlParameter("@ShopProductCategoryID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ShopProductCategoryID", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[27] = new SqlCommand();
			this._commandCollection[27].Connection = this.Connection;
			this._commandCollection[27].CommandText = "pr_DeleteProductByProductIDArray";
			this._commandCollection[27].CommandType = CommandType.StoredProcedure;
			this._commandCollection[27].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[27].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.VarChar, 300, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[28] = new SqlCommand();
			this._commandCollection[28].Connection = this.Connection;
			this._commandCollection[28].CommandText = "pr_SetProductEliteByProductIDArray";
			this._commandCollection[28].CommandType = CommandType.StoredProcedure;
			this._commandCollection[28].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[28].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.VarChar, 300, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[29] = new SqlCommand();
			this._commandCollection[29].Connection = this.Connection;
			this._commandCollection[29].CommandText = "pr_StopSaleProductByProductID";
			this._commandCollection[29].CommandType = CommandType.StoredProcedure;
			this._commandCollection[29].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[29].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.VarChar, 300, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[30] = new SqlCommand();
			this._commandCollection[30].Connection = this.Connection;
			this._commandCollection[30].CommandText = "Pr_SearchProductList";
			this._commandCollection[30].CommandType = CommandType.StoredProcedure;
			this._commandCollection[30].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[30].Parameters.Add(new SqlParameter("@PageSize", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[30].Parameters.Add(new SqlParameter("@PageIndex", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[30].Parameters.Add(new SqlParameter("@Counts", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[30].Parameters.Add(new SqlParameter("@strWhere", SqlDbType.VarChar, 3000, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[30].Parameters.Add(new SqlParameter("@strOrderBy", SqlDbType.VarChar, 300, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[31] = new SqlCommand();
			this._commandCollection[31].Connection = this.Connection;
			this._commandCollection[31].CommandText = "UPDATE HLShop_Product\r\nSET IsElite = @IsElite\r\nWHERE (ProductID = @ProductID)";
			this._commandCollection[31].CommandType = CommandType.Text;
			this._commandCollection[31].Parameters.Add(new SqlParameter("@IsElite", SqlDbType.Bit, 1, ParameterDirection.Input, 0, 0, "IsElite", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[31].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[32] = new SqlCommand();
			this._commandCollection[32].Connection = this.Connection;
			this._commandCollection[32].CommandText = "UPDATE [HLShop_Product] SET [EnableSale] =0,[UpdateTime] = GetDate() WHERE (([SalerID] = @SalerID))";
			this._commandCollection[32].CommandType = CommandType.Text;
			this._commandCollection[32].Parameters.Add(new SqlParameter("@SalerID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "SalerID", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[33] = new SqlCommand();
			this._commandCollection[33].Connection = this.Connection;
			this._commandCollection[33].CommandText = "update [HLShop_Product] set ShopProductClassID=@ShopProductClassID  WHERE (([ProductID] = @ProductID)) ";
			this._commandCollection[33].CommandType = CommandType.Text;
			this._commandCollection[33].Parameters.Add(new SqlParameter("@ShopProductClassID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ShopProductClassID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[33].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[34] = new SqlCommand();
			this._commandCollection[34].Connection = this.Connection;
			this._commandCollection[34].CommandText = "UPDATE [HLShop_Product] SET  [Hits] = Hits+1 \r\nWHERE ProductID=@ProductID";
			this._commandCollection[34].CommandType = CommandType.Text;
			this._commandCollection[34].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[35] = new SqlCommand();
			this._commandCollection[35].Connection = this.Connection;
			this._commandCollection[35].CommandText = "update [HLShop_Product] set EnableSale=@EnableSale  WHERE (([ProductID] = @ProductID))";
			this._commandCollection[35].CommandType = CommandType.Text;
			this._commandCollection[35].Parameters.Add(new SqlParameter("@EnableSale", SqlDbType.Bit, 1, ParameterDirection.Input, 0, 0, "EnableSale", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[35].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Original, false, null, "", "", ""));
		}
		[DataObjectMethod(DataObjectMethodType.Select, true), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetAllProducts()
		{
			this.Adapter.SelectCommand = this.CommandCollection[0];
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable AddProductAndGetProductID(int? ShopID, int? SalerID, int? ChannelID, string ProductPlace, string ProductNum, int? ClassID, string ProductName, string ProductModel, string ProductStandard, string ProducerName, string TrademarkName, string ProductIntro, string ProductImageUrl, string ProductType, decimal? StandPrice, decimal? AuctionStartPrice, decimal? ImcrementPrice, decimal? MemberPrice, string TeamName, int? TeamNum, decimal? TeamPrice1, decimal? TempSubScriptionRate, int? TeamNumber1, decimal? TeamPrice2, int? TeamNumber2, decimal? TeamPrice3, int? TeamNumber3, decimal? TeamPrice4, int? TeamNumber4, decimal? TeamPrice5, int? TeamNumber5, bool? IsElite, int? Stocks, bool? EnableSale, string Keyword, string Inputer, int? SalePromotionType, int? Weight, string Propority, string DeliverType, string DeliverCharge, bool? NeedInvoice, bool? Guarantee, int? ValidDay, bool? AutoPostBack, string Remark, int? DeliverPayType, string OnlinePayType, string PayType, int? Hits, int? BuyTimes, bool? OnTop, bool? IsHot, int? Stars, System.DateTime? BeginDate, System.DateTime? EndDate, int? LimitNum, bool? EnableSingleSell, int? TemplateID, int? SkinID, int? Discount, int? PresentExp, int? PresentPoint, decimal? PresentMoney, int? Discount1, int? PresentExp1, int? PresentPoint1, decimal? PresentMoney1, int? Discount2, int? PresentExp2, int? PresentPoint2, decimal? PresentMoney2, int? Discount3, int? PresentExp3, int? PresentPoint3, decimal? PresentMoney3, string PUnit, string ProductSmallImageUrl, decimal? TaxRate, string UploadFiles, string Color, string Size)
		{
			this.Adapter.SelectCommand = this.CommandCollection[1];
			if (ShopID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = ShopID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (SalerID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = SalerID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (ChannelID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = ChannelID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			if (ProductPlace == null)
			{
				this.Adapter.SelectCommand.Parameters[4].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[4].Value = ProductPlace;
			}
			if (ProductNum == null)
			{
				this.Adapter.SelectCommand.Parameters[5].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[5].Value = ProductNum;
			}
			if (ClassID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[6].Value = ClassID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[6].Value = System.DBNull.Value;
			}
			if (ProductName == null)
			{
				this.Adapter.SelectCommand.Parameters[7].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[7].Value = ProductName;
			}
			if (ProductModel == null)
			{
				this.Adapter.SelectCommand.Parameters[8].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[8].Value = ProductModel;
			}
			if (ProductStandard == null)
			{
				this.Adapter.SelectCommand.Parameters[9].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[9].Value = ProductStandard;
			}
			if (ProducerName == null)
			{
				this.Adapter.SelectCommand.Parameters[10].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[10].Value = ProducerName;
			}
			if (TrademarkName == null)
			{
				this.Adapter.SelectCommand.Parameters[11].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[11].Value = TrademarkName;
			}
			if (ProductIntro == null)
			{
				this.Adapter.SelectCommand.Parameters[12].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[12].Value = ProductIntro;
			}
			if (ProductImageUrl == null)
			{
				this.Adapter.SelectCommand.Parameters[13].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[13].Value = ProductImageUrl;
			}
			if (ProductType == null)
			{
				this.Adapter.SelectCommand.Parameters[14].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[14].Value = ProductType;
			}
			if (StandPrice.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[15].Value = StandPrice.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[15].Value = System.DBNull.Value;
			}
			if (AuctionStartPrice.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[16].Value = AuctionStartPrice.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[16].Value = System.DBNull.Value;
			}
			if (ImcrementPrice.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[17].Value = ImcrementPrice.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[17].Value = System.DBNull.Value;
			}
			if (MemberPrice.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[18].Value = MemberPrice.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[18].Value = System.DBNull.Value;
			}
			if (TeamName == null)
			{
				this.Adapter.SelectCommand.Parameters[19].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[19].Value = TeamName;
			}
			if (TeamNum.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[20].Value = TeamNum.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[20].Value = System.DBNull.Value;
			}
			if (TeamPrice1.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[21].Value = TeamPrice1.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[21].Value = System.DBNull.Value;
			}
			if (TempSubScriptionRate.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[22].Value = TempSubScriptionRate.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[22].Value = System.DBNull.Value;
			}
			if (TeamNumber1.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[23].Value = TeamNumber1.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[23].Value = System.DBNull.Value;
			}
			if (TeamPrice2.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[24].Value = TeamPrice2.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[24].Value = System.DBNull.Value;
			}
			if (TeamNumber2.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[25].Value = TeamNumber2.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[25].Value = System.DBNull.Value;
			}
			if (TeamPrice3.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[26].Value = TeamPrice3.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[26].Value = System.DBNull.Value;
			}
			if (TeamNumber3.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[27].Value = TeamNumber3.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[27].Value = System.DBNull.Value;
			}
			if (TeamPrice4.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[28].Value = TeamPrice4.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[28].Value = System.DBNull.Value;
			}
			if (TeamNumber4.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[29].Value = TeamNumber4.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[29].Value = System.DBNull.Value;
			}
			if (TeamPrice5.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[30].Value = TeamPrice5.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[30].Value = System.DBNull.Value;
			}
			if (TeamNumber5.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[31].Value = TeamNumber5.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[31].Value = System.DBNull.Value;
			}
			if (IsElite.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[32].Value = IsElite.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[32].Value = System.DBNull.Value;
			}
			if (Stocks.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[33].Value = Stocks.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[33].Value = System.DBNull.Value;
			}
			if (EnableSale.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[34].Value = EnableSale.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[34].Value = System.DBNull.Value;
			}
			if (Keyword == null)
			{
				this.Adapter.SelectCommand.Parameters[35].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[35].Value = Keyword;
			}
			if (Inputer == null)
			{
				this.Adapter.SelectCommand.Parameters[36].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[36].Value = Inputer;
			}
			if (SalePromotionType.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[37].Value = SalePromotionType.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[37].Value = System.DBNull.Value;
			}
			if (Weight.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[38].Value = Weight.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[38].Value = System.DBNull.Value;
			}
			if (Propority == null)
			{
				this.Adapter.SelectCommand.Parameters[39].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[39].Value = Propority;
			}
			if (DeliverType == null)
			{
				this.Adapter.SelectCommand.Parameters[40].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[40].Value = DeliverType;
			}
			if (DeliverCharge == null)
			{
				this.Adapter.SelectCommand.Parameters[41].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[41].Value = DeliverCharge;
			}
			if (NeedInvoice.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[42].Value = NeedInvoice.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[42].Value = System.DBNull.Value;
			}
			if (Guarantee.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[43].Value = Guarantee.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[43].Value = System.DBNull.Value;
			}
			if (ValidDay.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[44].Value = ValidDay.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[44].Value = System.DBNull.Value;
			}
			if (AutoPostBack.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[45].Value = AutoPostBack.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[45].Value = System.DBNull.Value;
			}
			if (Remark == null)
			{
				this.Adapter.SelectCommand.Parameters[46].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[46].Value = Remark;
			}
			if (DeliverPayType.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[47].Value = DeliverPayType.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[47].Value = System.DBNull.Value;
			}
			if (OnlinePayType == null)
			{
				this.Adapter.SelectCommand.Parameters[48].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[48].Value = OnlinePayType;
			}
			if (PayType == null)
			{
				this.Adapter.SelectCommand.Parameters[49].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[49].Value = PayType;
			}
			if (Hits.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[50].Value = Hits.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[50].Value = System.DBNull.Value;
			}
			if (BuyTimes.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[51].Value = BuyTimes.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[51].Value = System.DBNull.Value;
			}
			if (OnTop.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[52].Value = OnTop.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[52].Value = System.DBNull.Value;
			}
			if (IsHot.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[53].Value = IsHot.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[53].Value = System.DBNull.Value;
			}
			if (Stars.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[54].Value = Stars.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[54].Value = System.DBNull.Value;
			}
			if (BeginDate.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[55].Value = BeginDate.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[55].Value = System.DBNull.Value;
			}
			if (EndDate.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[56].Value = EndDate.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[56].Value = System.DBNull.Value;
			}
			if (LimitNum.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[57].Value = LimitNum.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[57].Value = System.DBNull.Value;
			}
			if (EnableSingleSell.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[58].Value = EnableSingleSell.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[58].Value = System.DBNull.Value;
			}
			if (TemplateID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[59].Value = TemplateID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[59].Value = System.DBNull.Value;
			}
			if (SkinID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[60].Value = SkinID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[60].Value = System.DBNull.Value;
			}
			if (Discount.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[61].Value = Discount.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[61].Value = System.DBNull.Value;
			}
			if (PresentExp.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[62].Value = PresentExp.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[62].Value = System.DBNull.Value;
			}
			if (PresentPoint.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[63].Value = PresentPoint.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[63].Value = System.DBNull.Value;
			}
			if (PresentMoney.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[64].Value = PresentMoney.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[64].Value = System.DBNull.Value;
			}
			if (Discount1.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[65].Value = Discount1.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[65].Value = System.DBNull.Value;
			}
			if (PresentExp1.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[66].Value = PresentExp1.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[66].Value = System.DBNull.Value;
			}
			if (PresentPoint1.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[67].Value = PresentPoint1.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[67].Value = System.DBNull.Value;
			}
			if (PresentMoney1.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[68].Value = PresentMoney1.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[68].Value = System.DBNull.Value;
			}
			if (Discount2.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[69].Value = Discount2.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[69].Value = System.DBNull.Value;
			}
			if (PresentExp2.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[70].Value = PresentExp2.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[70].Value = System.DBNull.Value;
			}
			if (PresentPoint2.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[71].Value = PresentPoint2.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[71].Value = System.DBNull.Value;
			}
			if (PresentMoney2.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[72].Value = PresentMoney2.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[72].Value = System.DBNull.Value;
			}
			if (Discount3.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[73].Value = Discount3.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[73].Value = System.DBNull.Value;
			}
			if (PresentExp3.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[74].Value = PresentExp3.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[74].Value = System.DBNull.Value;
			}
			if (PresentPoint3.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[75].Value = PresentPoint3.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[75].Value = System.DBNull.Value;
			}
			if (PresentMoney3.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[76].Value = PresentMoney3.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[76].Value = System.DBNull.Value;
			}
			if (PUnit == null)
			{
				this.Adapter.SelectCommand.Parameters[77].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[77].Value = PUnit;
			}
			if (ProductSmallImageUrl == null)
			{
				this.Adapter.SelectCommand.Parameters[78].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[78].Value = ProductSmallImageUrl;
			}
			if (TaxRate.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[79].Value = TaxRate.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[79].Value = System.DBNull.Value;
			}
			if (UploadFiles == null)
			{
				this.Adapter.SelectCommand.Parameters[80].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[80].Value = UploadFiles;
			}
			if (Color == null)
			{
				this.Adapter.SelectCommand.Parameters[81].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[81].Value = Color;
			}
			if (Size == null)
			{
				this.Adapter.SelectCommand.Parameters[82].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[82].Value = Size;
			}
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetAdminProductClassSum()
		{
			this.Adapter.SelectCommand = this.CommandCollection[3];
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetAuctionCurrentPrice(int ProductID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[4];
			this.Adapter.SelectCommand.Parameters[0].Value = ProductID;
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetAuctionProductByProductID(int? ProductID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[5];
			if (ProductID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = ProductID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetOnSaleProductBySalerID(int? SalerID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[6];
			if (SalerID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = SalerID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetProductByCategoryIDShopIDKeywords(int? CateGoryID, int? ShopID, string Keywords, string DateTimeSect)
		{
			this.Adapter.SelectCommand = this.CommandCollection[7];
			if (CateGoryID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = CateGoryID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (ShopID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = ShopID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (Keywords == null)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = Keywords;
			}
			if (DateTimeSect == null)
			{
				this.Adapter.SelectCommand.Parameters[4].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[4].Value = DateTimeSect;
			}
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetProductByClassID(int? ParentID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[8];
			if (ParentID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = ParentID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetProductByProducerName(string ProducerName)
		{
			this.Adapter.SelectCommand = this.CommandCollection[9];
			if (ProducerName == null)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = ProducerName;
			}
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetProductByProductID(int ProductID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[10];
			this.Adapter.SelectCommand.Parameters[0].Value = ProductID;
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetProductBySalerIDNameType(int? SalerID, string ProductName, string ProductType)
		{
			this.Adapter.SelectCommand = this.CommandCollection[11];
			if (SalerID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = SalerID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (ProductName == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = ProductName;
			}
			if (ProductType == null)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = ProductType;
			}
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetProductByShopCategoryID(int? shopid, int? ShopProductClassID, string KeyWords)
		{
			this.Adapter.SelectCommand = this.CommandCollection[12];
			if (shopid.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = shopid.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (ShopProductClassID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = ShopProductClassID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (KeyWords == null)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = KeyWords;
			}
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Fill, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int GetProductByShopIDProductNameProductType1(S_Product.HLShop_ProductDataTable dataTable, int? ShopID, string ProducerName, string ProductType)
		{
			this.Adapter.SelectCommand = this.CommandCollection[13];
			if (ShopID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = ShopID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (ProducerName == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = ProducerName;
			}
			if (ProductType == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = ProductType;
			}
			if (this.ClearBeforeFill)
			{
				dataTable.Clear();
			}
			return this.Adapter.Fill(dataTable);
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetProductByShopIDProductNameProductType(int? ShopID, string ProducerName, string ProductType)
		{
			this.Adapter.SelectCommand = this.CommandCollection[13];
			if (ShopID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = ShopID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (ProducerName == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = ProducerName;
			}
			if (ProductType == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = ProductType;
			}
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetProductInStock(int? SalerID, string StockType)
		{
			this.Adapter.SelectCommand = this.CommandCollection[16];
			if (SalerID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = SalerID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (StockType == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = StockType;
			}
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetProductIsOntoporHot(string Type)
		{
			this.Adapter.SelectCommand = this.CommandCollection[17];
			if (Type == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = Type;
			}
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetProductIsOnTopOrHotClassID(string Type, int? ClassID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[18];
			if (Type == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = Type;
			}
			if (ClassID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = ClassID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetProductPerPage(string tblName, string strGetFields, string fldName, int? PageSize, int? PageIndex, int? OrderType, string strWhere, int? Counts)
		{
			this.Adapter.SelectCommand = this.CommandCollection[19];
			if (tblName == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = tblName;
			}
			if (strGetFields == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = strGetFields;
			}
			if (fldName == null)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = fldName;
			}
			if (PageSize.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[4].Value = PageSize.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[4].Value = System.DBNull.Value;
			}
			if (PageIndex.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[5].Value = PageIndex.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[5].Value = System.DBNull.Value;
			}
			if (OrderType.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[6].Value = OrderType.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[6].Value = System.DBNull.Value;
			}
			if (strWhere == null)
			{
				this.Adapter.SelectCommand.Parameters[7].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[7].Value = strWhere;
			}
			if (Counts.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[8].Value = Counts.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[8].Value = System.DBNull.Value;
			}
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetProductsByProductPlace(string ProductPlace)
		{
			this.Adapter.SelectCommand = this.CommandCollection[20];
			if (ProductPlace == null)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = ProductPlace;
			}
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetProductsByProductType(string ProductType)
		{
			this.Adapter.SelectCommand = this.CommandCollection[21];
			if (ProductType == null)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = ProductType;
			}
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetProductsForCompareByProductID(string ProductID_Array)
		{
			this.Adapter.SelectCommand = this.CommandCollection[22];
			if (ProductID_Array == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = ProductID_Array;
			}
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetRecommendProductBySalerID(int? SalerID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[23];
			if (SalerID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = SalerID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetShopUploadProductFile(string NickName, string UploadFileName, int? U_Identify)
		{
			this.Adapter.SelectCommand = this.CommandCollection[24];
			if (NickName == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = NickName;
			}
			if (UploadFileName == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = UploadFileName;
			}
			if (U_Identify.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = U_Identify.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable GetTop5RecommendProductByShopID(int? ShopID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[25];
			if (ShopID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = ShopID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Product.HLShop_ProductDataTable SearchProductList(int? PageSize, int? PageIndex, int? Counts, string strWhere, string strOrderBy)
		{
			this.Adapter.SelectCommand = this.CommandCollection[30];
			if (PageSize.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = PageSize.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (PageIndex.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = PageIndex.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (Counts.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = Counts.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			if (strWhere == null)
			{
				this.Adapter.SelectCommand.Parameters[4].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[4].Value = strWhere;
			}
			if (strOrderBy == null)
			{
				this.Adapter.SelectCommand.Parameters[5].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[5].Value = strOrderBy;
			}
			S_Product.HLShop_ProductDataTable hLShop_ProductDataTable = new S_Product.HLShop_ProductDataTable();
			this.Adapter.Fill(hLShop_ProductDataTable);
			return hLShop_ProductDataTable;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(S_Product.HLShop_ProductDataTable dataTable)
		{
			return this.Adapter.Update(dataTable);
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(S_Product dataSet)
		{
			return this.Adapter.Update(dataSet, "HLShop_Product");
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(DataRow dataRow)
		{
			return this.Adapter.Update(new DataRow[]
			{
				dataRow
			});
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(DataRow[] dataRows)
		{
			return this.Adapter.Update(dataRows);
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int EditProductByProductID(string ProductID, string Type)
		{
			SqlCommand sqlCommand = this.CommandCollection[2];
			if (ProductID == null)
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = ProductID;
			}
			if (Type == null)
			{
				sqlCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[2].Value = Type;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int? GetProductByUploadPic(string filepath)
		{
			SqlCommand sqlCommand = this.CommandCollection[14];
			if (filepath == null)
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = filepath;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			object obj;
			try
			{
				obj = sqlCommand.ExecuteScalar();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			int? result;
			if (obj == null || obj.GetType() == typeof(System.DBNull))
			{
				result = null;
			}
			else
			{
				result = new int?((int)obj);
			}
			return result;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int? GetProductCount()
		{
			SqlCommand sqlCommand = this.CommandCollection[15];
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			object obj;
			try
			{
				obj = sqlCommand.ExecuteScalar();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			int? result;
			if (obj == null || obj.GetType() == typeof(System.DBNull))
			{
				result = null;
			}
			else
			{
				result = new int?((int)obj);
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int MoveShopProductCategory(int? ShopProductCategoryID)
		{
			SqlCommand sqlCommand = this.CommandCollection[26];
			if (ShopProductCategoryID.HasValue)
			{
				sqlCommand.Parameters[0].Value = ShopProductCategoryID.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Product_DeleteProductByProductIDArray(string ProductID)
		{
			SqlCommand sqlCommand = this.CommandCollection[27];
			if (ProductID == null)
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = ProductID;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Product_SetProductEliteByProductIDArray(string ProductID)
		{
			SqlCommand sqlCommand = this.CommandCollection[28];
			if (ProductID == null)
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = ProductID;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Product_StopSaleProductByProductID(string ProductID)
		{
			SqlCommand sqlCommand = this.CommandCollection[29];
			if (ProductID == null)
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = ProductID;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int SetProductElite(bool? IsElite, int ProductID)
		{
			SqlCommand sqlCommand = this.CommandCollection[31];
			if (IsElite.HasValue)
			{
				sqlCommand.Parameters[0].Value = IsElite.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			sqlCommand.Parameters[1].Value = ProductID;
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int StopSaleProductBySalerID(int? SalerID)
		{
			SqlCommand sqlCommand = this.CommandCollection[32];
			if (SalerID.HasValue)
			{
				sqlCommand.Parameters[0].Value = SalerID.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int UpdateProductClass(int? ShopProductClassID, int ProductID)
		{
			SqlCommand sqlCommand = this.CommandCollection[33];
			if (ShopProductClassID.HasValue)
			{
				sqlCommand.Parameters[0].Value = ShopProductClassID.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			sqlCommand.Parameters[1].Value = ProductID;
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int UpdateProductHits(int ProductID)
		{
			SqlCommand sqlCommand = this.CommandCollection[34];
			sqlCommand.Parameters[0].Value = ProductID;
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int UpdateProductSetupdateEnableSale(bool? EnableSale, int ProductID)
		{
			SqlCommand sqlCommand = this.CommandCollection[35];
			if (EnableSale.HasValue)
			{
				sqlCommand.Parameters[0].Value = EnableSale.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			sqlCommand.Parameters[1].Value = ProductID;
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
	}
}
